[5882] Geospatial System Operator (TH)

Start date: Negotiable
Clearance: NATO Secret or equivalent
Location: The Hague, Netherlands

Experience:
• Minimum 3 years' experience with Microsoft SQL Server & Database Development, including: Advanced SQL (complex joins, CTEs, window functions, indexing strategies), Stored procedures, functions, triggers, Query optimization and performance tuning, Data modeling (conceptual, logical, physical), Normalization and denormalization strategies and ETL process design;
• Minimum of 3 years' experience and deep knowledge in all IT aspects of the Esri enterprises, including: ArcGIS Pro, ArcGIS Portal and ArcGIS Server
• Minimum of 3 years' experience and deep knowledge in configuration and maintenance of Esri components (Experience Builder, Dashboards, Story Maps, etc.)
• Excellent knowledge of Commercial Satellite Imagery, formats and metadata;
• Excellent knowledge of vector data manipulation and data management in a complex multi- network/multi-user environment;
• Experience in automating GIS workflows;

Duties:
• Design conceptual, logical, and physical spatial data models
• Implement enterprise geodatabases using Microsoft SQL Server
• Optimize complex SQL queries and spatial joins
• Create stored procedures, triggers, and database functions
• Deploy and manage geodatabases for ArcGIS Enterprise
• Monitor database health and resource utilization
• Implement performance monitoring tools
• Optimize Storage straegies for large datasets
• Automate database maintenance tasks (vacuum, indexing, statistics updates)
• Develop scripts for backup validation and restore testing
• Translate business requirements into spatial database architecture
• Collaborate with GIS analysts, developers, and IT teams
• Provide technical documentation and system diagrams
• Lead troubleshooting and root cause analysis
• Contribute to architectural decision-making
• Integrate in current Image provisioning Team
• Operate established multi-source imagery provisioning service including trouble shooting
• Manage all relevant imagery and other data